Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
TillID (FK)(PK) | The unique identifier for the TENDER RESPOSITORY. | ID_RPSTY_TND | Identity | integer | Till(AS_TL) |
TransactionID (FK)(PK) | A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. | ID_TRN | IdentityUUID | char(32) | TillTenderSettlementTransaction(TR_TND_STLM_TL) |
TotalTransactionCount | The total number of transactions entered during the settlement period. | QU_TRN_TOT | QuantityTransactionCount | decimal(7,0) | |
NetSalesTotalAmount | The total monetary amount of net sales entered during the settlement period. | CP_SLS_NT_TOT | Money | decimal(16,5) | |
TaxTotalAmount | The total tax amount recorded entered during the settlement period. | CP_TX_TOT | Money | decimal(16,5) | |
GrossSalesExTaxTotalAmount | The total monetary amount of gross sales excluding tax entered during the settlement period. | TP_SLS_EX_TX_TOT | Money | decimal(16,5) | |
TotalTenderLoanCount | The total number of tender loans entered during the settlement period. | QU_LON_TND_TOT | QuantityTransactionCount | decimal(7,0) | |
GrossPositiveTotalAmount | The total monetary amount of positive sales entered during the settlement period. | TP_SLS_GS_PSTV_TOT | Money | decimal(16,5) | |
GrossNegativeTotalAmount | The total monetary amount of negative sales entered during the settlement period. | TP_SLS_GS_NG_TOT | Money | decimal(16,5) | |
LineItemVoidTotalAmount | The total monetary amount of line item voids entered during the settlement period. | CP_VD_LN_ITM_TOT | Money | decimal(16,5) | |
TotalLineItemVoidCount | The total number of line item voids entered during the settlement period. | QU_VD_LN_ITM_TOT | QuantityTransactionCount | decimal(7,0) | |
PostTransactionVoidTotalAmount | The total monetary amount of post transaction voids entered during the settlement period. | CP_VD_PS_TRN | Money | decimal(16,5) | |
TotalPostTransactionVoidCount | The total number of post-transaction voids entered during the settlement period. | QU_VD_PST_TRN_TOT | QuantityTransactionCount | decimal(7,0) | |
TransactionVoidTotalAmount | The total monetary amount of transaction voids entered during the settlement period. | CP_VD_TRN_TOT | Money | decimal(16,5) | |
TotalTransactionVoidCount | The total number of transaction voids entered during the settlement period. | QU_VD_TRN_TOT | QuantityTransactionCount | decimal(7,0) | |
TotalTenderPickupCount | The total number of tender pickups entered during the settlement period. | QU_PKP_TND_TOT | QuantityTransactionCount | decimal(7,0) | |
TenderLoanTotalAmount | The total monetary amount of tender loans entered during the settlement period. | CP_LON_TND_TOT | Money | decimal(16,5) | |
TenderPickupTotalAmount | The total monetary amount of tender entered during the settlement period. | CP_PKP_TND_TOT | Money | decimal(16,5) | |
ReturnTotalAmount | The total monetary amount of returns entered during the settlement period. | CP_RTN_TOT | Money | decimal(16,5) | |
TotalReturnCount | The total number of returns entered during the settlement period. | QU_RTN_TOT | QuantityTransactionCount | decimal(7,0) | |
RefundTotalAmount | The total monetary amount of refunds entered during the settlement period. | CP_RFD_TOT | Money | decimal(16,5) | |
TotalRefundCount | The total number of refunds entered during the settlement period. | QU_RFD_TOT | QuantityTransactionCount | decimal(7,0) | |
EmployeeDiscountTotalAmount | The total monetary amount of employee discounts entered during the settlement period. | CP_DS_EM_TOT | Money | decimal(16,5) | |
TotalEmployeeDiscountCount | The number of employee discount line items entered during the settlement period. | QU_DSC_EM | QuantityTransactionCount | decimal(7,0) | |
MiscellaneousDiscountTotalAmount | The total monetary amount of miscellaneous discounts entered during the settlement period. | CP_DSC_MSC_TOT | Money | decimal(16,5) | |
TotalMiscellaneousDiscountCount | The total number of miscellaneous discount line itemsentered during the settlement period. | QU_DSC_MSC_TOT | QuantityTransactionCount | decimal(7,0) | |
StoreCouponTotalAmount | The total monetary amount of store coupons accepted entered during the settlement period. | CP_CPN_STR_TOT | Money | decimal(16,5) | |
TotalStoreCouponCount | The total number of store coupons accepted entered during the settlement period. | QU_CPN_STR_TOT | QuantityTransactionCount | decimal(7,0) | |
RedeemedContainerDepositTotalAmount | The total monetary amount of container deposits redeemed entered during the settlement period. | CP_DS_RDM_CNR_TOT | Money | decimal(16,5) | |
TotalRedeemedContainerDepositCount | The total number of container deposits redeemed entered during the settlement period. | QU_DS_RDM_CNR | QuantityTransactionCount | decimal(7,0) | |
MarkdownTotalAmount | The total monetary amount of markdowns entered during the settlement period. | CP_MKD_TOT | Money | decimal(16,5) | |
TotalMarkdownCount | The total number of markdowns recorded entered during the settlement period. | QU_MKD_TOT | QuantityTransactionCount | decimal(7,0) | |
MiscellaneousFeeTotalAmount | The total monetary amount of miscellaneous fees entered during the settlement period. | CP_FE_MSC_TOT | Money | decimal(16,5) | |
TotalMiscellaneousFeeCount | The total number of miscellaneous fees line items entered during the settlement period. | QU_FE_MSC_TOT | QuantityTransactionCount | decimal(7,0) | |
ContainerDepositTotalAmount | The total monetary amount of container deposits collected entered during the settlement period. | CP_DS_CNR_TOT | Money | decimal(16,5) | |
TotalContainerDepositCount | The total number of container deposits collected entered during the settlement period. | QU_DS_CNTR_TOT | QuantityTransactionCount | decimal(7,0) | |
PaymentsCollectedTotalAmount | The total monetary amount of payments on account collected by TILL for each REPORTING PERIOD. | CP_PYM_CLT_TOT | Money | decimal(16,5) | |
TotalPaymentsCollectedCount | The total number of payments on account collected entered during the settlement period. | QU_PYM_CLT_TOT | QuantityTransactionCount | decimal(7,0) | |
PettyCashDisbursementTotalAmount | The total monetary amount of cash disbursements entered during the settlement period. | CP_DSB_PTY_CSH_TOT | Money | decimal(16,5) | |
TotalPettyCashDisbursementLineItemCount | The total number of cash disbursement line items entered during the settlement period. | QU_DSB_PTY_LN_ITM | QuantityTransactionCount | decimal(7,0) | |
TaxExemptTotalAmount | The total tax exempt amount entered during the settlement period. | CP_TX_EXM_TOT | Money | decimal(16,5) | |
TotalTaxExemptTransactionCount | The total number of tax exempt transactions entered during the settlement period. | QU_TRN_TX_EXM_TOT | QuantityTransactionCount | decimal(7,0) | |
TotalLineItemOverrideCount | The total number of line item overrides entered during the settlement period. | QU_OVRD_LN_ITM_TOT | QuantityTransactionCount | decimal(7,0) | |
TotalWeighedLineItemCount | The total number of weighed line items entered during the settlement period. | QU_ITM_LN_WT_TOT | QuantityTransactionCount | decimal(7,0) | |
TotalLineItemKeyedCount | The total number of Items keyed at the point of sale during the settlement period. | QU_KY_LN_ITM_TOT | QuantityTransactionCount | decimal(7,0) | |
TotalLineItemScannedCount | The total number of ITEMs scanned during the settlement period. | QU_SC_LN_ITM_TOT | QuantityTransactionCount | decimal(7,0) | |
TotalLineItemKeyedPercentage | The percentage of Items keyed at the point of sale compared to the total sold Items during the settlement period. | PE_KY_LN_ITM_TOT | Percent | decimal(7,4) | |
TotalLineItemScannedPercentage | The percentage of Items scanned compared to the total sold Items during the settlement period. | PE_SC_LN_ITM_TOT | Percent | decimal(7,4) | |
TotalLineItemOpenDepartmentCount | The number of Items recorded through an open department during the settlement period. | QU_DPT_OPN_LN_ITM | QuantityTransactionCount | decimal(7,0) | |
TotalLineItemOpenDepartmentPercentage | The percentage of Items recorded through an open department compared to the total Items during the settlement period. | PE_DPT_OPN_LN_ITM | Percent | decimal(7,4) | |
TotalNoSaleTransactionCount | The total number of no sale transactions entered during the settlement period. | QU_TRN_NO_SLS_TOT | QuantityTransactionCount | decimal(7,0) | |
TotalRingTime | The total time expressed in minutes of the time taken to either scan or key line item sales during the settlement period. | IN_RNG_TOT | QuantityShortCountMinutes | decimal(4,0) | |
TotalIdleTime | The total time expressed in minutes where no sales are being recorded during the settlement period. | IN_IDL_TOT | QuantityShortCountMinutes | decimal(4,0) | |
TotalLockTime | The total time expressed in minutes where a Workstation is locked even though an Operator remains signed-on during the settlement period. | IN_LCK_TOT | QuantityShortCountMinutes | decimal(4,0) | |
TotalTenderTime | The total time expressed in minutes of the time taken tender sales during the settlement period. | IN_TOT_TND | QuantityShortCountMinutes | decimal(4,0) | |
TotalSaleLineItemCount | The total number of line item sales entered during the settlement period. | QU_ITM_LN_SLS_TOT | QuantityTransactionCount | decimal(7,0) | |
TipOutAmount | The monetary value of the tips paid out of a till to restaurant servers and other tippable staf for a period of time bounded by TillSettlementTransactions. | MO_TPOT_AMT | MoneyShortRetail | decimal(7,2) | |
FundsReceiptAmount | The aggregated monetary value of the funds received into a till through a TenderControlTransaction, not a RetailTransaction over a period of time bounded by TillSettlementTransactions. Typically funds receipts are transactions captured on non-POS workstations outside the functional scope of retail transactions. | MO_FND_RCT_AMT | MoneyShortRetail | decimal(7,2) | |
DisbursementAmount | The aggregated monetary value of the funds paid out of a till through TenderControlTransactions, not RetailTransactions, over a period of time bounded by TillSettlementTransactions. | MO_DSB_AMT | MoneyShortRetail | decimal(7,2) | |
MarkdownCancellationTotalAmount | Total value of markdown cancellations entered or derived from processing returns for items that were marked down (POS markdown) at the time of sale. This reflects the reversal of the previous transaction's POS markdown. The total is summed for the period of time bounded by TillSettlementTransactions. | MO_MKD_CNL_TOT_AMT | MoneyShortRetail | decimal(7,2) | |
TotalMarkdownCancellationCount | Total COUNT of markdown cancellations entered or derived from processing returns for items that were marked down (POS markdown) at the time of sale. This reflects the reversal of the previous transaction's POS markdown. The total is summed for the period of time bounded by TillSettlementTransactions. | QU_TOT_MKD_CNL_CNT | QuantityTransactionCount | decimal(7,0) | |
TaxRefundAmount | Total monetary value of taxes refunded for merchandise returned (and accepted) by the retailer for the period of time bounded by TillSettlementTransactions. Tax refunds represent a reversal of tax collected when an item was sold. | MO_TX_RFD_AMT | MoneyShortRetail | decimal(7,2) | |